using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.F_ShopTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_ShopTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_ShopTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_Shop";
			dataTableMapping.ColumnMappings.Add("ShopID", "ShopID");
			dataTableMapping.ColumnMappings.Add("ShopOwnerID", "ShopOwnerID");
			dataTableMapping.ColumnMappings.Add("ShopName", "ShopName");
			dataTableMapping.ColumnMappings.Add("ShopAdUrl", "ShopAdUrl");
			dataTableMapping.ColumnMappings.Add("ShopAnnouncement", "ShopAnnouncement");
			dataTableMapping.ColumnMappings.Add("ShopGroupID", "ShopGroupID");
			dataTableMapping.ColumnMappings.Add("ShopRegDate", "ShopRegDate");
			dataTableMapping.ColumnMappings.Add("ShopCloseDate", "ShopCloseDate");
			dataTableMapping.ColumnMappings.Add("ShopClick", "ShopClick");
			dataTableMapping.ColumnMappings.Add("ShopHelp", "ShopHelp");
			dataTableMapping.ColumnMappings.Add("ShopIntro", "ShopIntro");
			dataTableMapping.ColumnMappings.Add("ShopTemplateID", "ShopTemplateID");
			dataTableMapping.ColumnMappings.Add("ShopCategoryID", "ShopCategoryID");
			dataTableMapping.ColumnMappings.Add("ShopChildID", "ShopChildID");
			dataTableMapping.ColumnMappings.Add("ShopImageUrl", "ShopImageUrl");
			dataTableMapping.ColumnMappings.Add("ShopClassID", "ShopClassID");
			dataTableMapping.ColumnMappings.Add("LastTimeLogin", "LastTimeLogin");
			dataTableMapping.ColumnMappings.Add("ShopOperatorItem", "ShopOperatorItem");
			dataTableMapping.ColumnMappings.Add("ShopProductClassID", "ShopProductClassID");
			dataTableMapping.ColumnMappings.Add("ShopURL", "ShopURL");
			dataTableMapping.ColumnMappings.Add("ShopIdentify", "ShopIdentify");
			dataTableMapping.ColumnMappings.Add("ShopCredit", "ShopCredit");
			dataTableMapping.ColumnMappings.Add("ShopStyle", "ShopStyle");
			dataTableMapping.ColumnMappings.Add("ShopOwnerName", "ShopOwnerName");
			dataTableMapping.ColumnMappings.Add("ShopStatus", "ShopStatus");
			dataTableMapping.ColumnMappings.Add("ShopProductNum", "ShopProductNum");
			dataTableMapping.ColumnMappings.Add("RecommendShop", "RecommendShop");
			dataTableMapping.ColumnMappings.Add("Tax", "Tax");
			dataTableMapping.ColumnMappings.Add("IsTax", "IsTax");
			dataTableMapping.ColumnMappings.Add("ShopAddress", "ShopAddress");
			dataTableMapping.ColumnMappings.Add("ZipCode", "ZipCode");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_Shop] WHERE (([ShopID] = @Original_ShopID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_Shop] ([ShopOwnerID], [ShopOwnerName], [ShopName], [ShopAdUrl], [ShopAnnouncement], [ShopGroupID], [ShopRegDate], [ShopCloseDate], [ShopClick], [ShopHelp], [ShopIntro], [ShopCredit], [ShopStatus], [ShopTemplateID], [ShopStyle], [ShopCategoryID], [ShopChildID], [ShopImageUrl], [RecommendShop], [LastTimeLogin], [ShopOperatorItem], [ShopProductClassID], [ShopURL], [ShopIdentify], [ShopProductNum], [Tax], [IsTax], [ShopAddress], [ZipCode]) VALUES (@ShopOwnerID, @ShopOwnerName, @ShopName, @ShopAdUrl, @ShopAnnouncement, @ShopGroupID, @ShopRegDate, @ShopCloseDate, @ShopClick, @ShopHelp, @ShopIntro, @ShopCredit, @ShopStatus, @ShopTemplateID, @ShopStyle, @ShopCategoryID, @ShopChildID, @ShopImageUrl, @RecommendShop, @LastTimeLogin, @ShopOperatorItem, @ShopProductClassID, @ShopURL, @ShopIdentify, @ShopProductNum, @Tax, @IsTax, @ShopAddress, @ZipCode)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopOwnerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopOwnerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopOwnerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopOwnerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopAdUrl", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopAdUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopAnnouncement", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopAnnouncement", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopGroupID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopGroupID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopRegDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "ShopRegDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopCloseDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "ShopCloseDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopClick", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopClick", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopHelp", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopHelp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopIntro", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopIntro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopCredit", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCredit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopTemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopTemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopStyle", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ShopStyle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopCategoryID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCategoryID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopChildID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopChildID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RecommendShop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "RecommendShop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LastTimeLogin", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LastTimeLogin", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopOperatorItem", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopOperatorItem", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopURL", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopURL", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopProductNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Tax", SqlDbType.Float, 0, ParameterDirection.Input, 0, 0, "Tax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsTax", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsTax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopAddress", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopAddress", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_Shop] SET [ShopOwnerID] = @ShopOwnerID, [ShopOwnerName] = @ShopOwnerName, [ShopName] = @ShopName, [ShopAdUrl] = @ShopAdUrl, [ShopAnnouncement] = @ShopAnnouncement, [ShopGroupID] = @ShopGroupID, [ShopRegDate] = @ShopRegDate, [ShopCloseDate] = @ShopCloseDate, [ShopClick] = @ShopClick, [ShopHelp] = @ShopHelp, [ShopIntro] = @ShopIntro, [ShopCredit] = @ShopCredit, [ShopStatus] = @ShopStatus, [ShopTemplateID] = @ShopTemplateID, [ShopStyle] = @ShopStyle, [ShopCategoryID] = @ShopCategoryID, [ShopChildID] = @ShopChildID, [ShopImageUrl] = @ShopImageUrl, [RecommendShop] = @RecommendShop, [LastTimeLogin] = @LastTimeLogin, [ShopOperatorItem] = @ShopOperatorItem, [ShopProductClassID] = @ShopProductClassID, [ShopURL] = @ShopURL, [ShopIdentify] = @ShopIdentify, [ShopProductNum] = @ShopProductNum, [Tax] = @Tax, [IsTax] = @IsTax, [ShopAddress] = @ShopAddress, [ZipCode] = @ZipCode WHERE (([ShopID] = @Original_ShopID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopOwnerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopOwnerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopOwnerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopOwnerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopAdUrl", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopAdUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopAnnouncement", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopAnnouncement", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopGroupID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopGroupID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopRegDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "ShopRegDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopCloseDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "ShopCloseDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopClick", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopClick", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopHelp", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopHelp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopIntro", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ShopIntro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopCredit", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCredit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopTemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopTemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopStyle", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ShopStyle", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopCategoryID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopCategoryID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopChildID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopChildID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RecommendShop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "RecommendShop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LastTimeLogin", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LastTimeLogin", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopOperatorItem", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopOperatorItem", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopURL", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopURL", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopProductNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Tax", SqlDbType.Float, 0, ParameterDirection.Input, 0, 0, "Tax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsTax", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsTax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopAddress", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ShopAddress", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[23];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT ShopID, ShopOwnerID, ShopOwnerName, ShopName, ShopAdUrl, \r\n      ShopAnnouncement, ShopGroupID, ShopRegDate, ShopCloseDate, ShopClick, ShopHelp, \r\n      ShopIntro, ShopCredit, ShopStatus, ShopTemplateID, ShopStyle, ShopCategoryID, \r\n      ShopChildID, ShopImageUrl, RecommendShop, LastTimeLogin, ShopOperatorItem, \r\n      ShopProductClassID, ShopURL, ShopIdentify, ShopProductNum, Tax, IsTax, \r\n      ShopAddress, ZipCode\r\nFROM HLShop_Shop";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "PR_GetLevelShop";
			this._commandCollection[1].CommandType = CommandType.StoredProcedure;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ShopGroupID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "SELECT TOP 20 IsTax, LastTimeLogin, RecommendShop, ShopAdUrl, ShopAddress, ShopAnnouncement, ShopCategoryID, ShopChildID, ShopClick, ShopCloseDate, ShopCredit, ShopHelp, ShopID, ShopIdentify, ShopImageUrl, ShopIntro, ShopGroupID, ShopName, ShopOperatorItem, ShopOwnerID, ShopOwnerName, ShopProductClassID, ShopProductNum, ShopRegDate, ShopStatus, ShopStyle, ShopTemplateID, ShopURL, Tax, ZipCode FROM HLShop_Shop WHERE (ShopIdentify = 1) AND (ShopStatus = 1) ORDER BY ShopRegDate DESC";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT  HLShop_Shop.RecommendShop,   HLShop_Shop.ShopID,  HLShop_Shop.ShopIdentify,   HLShop_Shop.ShopGroupID,  HLShop_Shop.ShopName,  HLShop_Shop.ShopOwnerID,  HLShop_Shop.ShopOwnerName,   HLShop_Shop.ShopProductNum,  HLShop_Shop.ShopRegDate,  HLShop_Shop.ShopStatus, HL_UserInfo.SaleCrediet  FROM HLShop_Shop Inner Join HL_UserInfo On HL_UserInfo.UserID=HLShop_Shop.ShopOwnerID WHERE (HLShop_Shop.RecommendShop = 1) AND (HLShop_Shop.ShopGroupID >=1) AND (HLShop_Shop.ShopStatus = 1)";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "pr_getshopbynameoweridoperatoritemaddressChildid";
			this._commandCollection[4].CommandType = CommandType.StoredProcedure;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@shopname", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@shopowername", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@shopoperatoritem", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@shopaddress", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@shopChildid", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "\r\n                      SELECT HLShop_Shop.*,HL_UserInfo.SaleCrediet,HL_UserInfo.BuyCrediet,HL_UserInfo.OICQ,HL_UserInfo.Taobaowangwang,HLShop_Class.ClassName FROM HLShop_Shop\r\n                      Inner Join HL_UserInfo On HLShop_Shop.ShopOwnerID=HL_UserInfo.UserID Left Join HLShop_Class On HLShop_Class.ClassID=HLShop_Shop.ShopCategoryID\r\n                      WHERE ( HLShop_Shop.ShopID = @ShopID)";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "Pr_GetShopByShopNameShopIdenfityShopStatus";
			this._commandCollection[6].CommandType = CommandType.StoredProcedure;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@ShopIdentify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@ShopStatus", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "SELECT COUNT(ShopID)As ShopID FROM HLShop_Shop";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "SELECT IsTax, LastTimeLogin, RecommendShop, ShopAdUrl, ShopAddress, ShopAnnouncement, ShopCategoryID, ShopChildID, ShopClick, ShopCloseDate, ShopCredit, ShopHelp, ShopID, ShopIdentify, ShopImageUrl, ShopIntro, ShopGroupID, ShopName, ShopOperatorItem, ShopOwnerID, ShopOwnerName, ShopProductClassID, ShopProductNum, ShopRegDate, ShopStatus, ShopStyle, ShopTemplateID, ShopURL, Tax, ZipCode FROM HLShop_Shop WHERE (ShopOwnerID = @ShopOwnerID)";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ShopOwnerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopOwnerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "PR_GetOrderPerPage";
			this._commandCollection[9].CommandType = CommandType.StoredProcedure;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "SELECT IsTax, LastTimeLogin, RecommendShop, ShopAdUrl, ShopAddress, ShopAnnouncement, ShopCategoryID, ShopChildID, ShopClick, ShopCloseDate, ShopCredit, ShopHelp, ShopID, ShopIdentify, ShopImageUrl, ShopIntro, ShopGroupID, ShopName, ShopOperatorItem, ShopOwnerID, ShopOwnerName, ShopProductClassID, ShopProductNum, ShopRegDate, ShopStatus, ShopStyle, ShopTemplateID, ShopURL, Tax, ZipCode FROM HLShop_Shop";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "Pr_GetShopUploadShopFile";
			this._commandCollection[11].CommandType = CommandType.StoredProcedure;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@UploadFileName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@U_Identify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "UPDATE HLShop_Shop\r\nSET ShopIdentify = @ShopIdentify\r\nWHERE (ShopID = @ShopID)";
			this._commandCollection[12].CommandType = CommandType.Text;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@ShopIdentify", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "PR_AddShop";
			this._commandCollection[13].CommandType = CommandType.StoredProcedure;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopOwnerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopAdUrl", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopAnnouncement", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopGroupID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopRegDate", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopCloseDate", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopClick", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopHelp", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopIntro", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopCredit", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopStatus", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopTemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopStyle", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopCategoryID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopChildID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopImageUrl", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@RecommendShop", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@Tax", SqlDbType.Float, 8, ParameterDirection.Input, 53, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@IsTax", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopAddress", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@LastTimeLogin", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopOperatorItem", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopURL", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopIdentify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopOwnerName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "pr_EditShopByShopID";
			this._commandCollection[14].CommandType = CommandType.StoredProcedure;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "UPDATE HLShop_Shop\r\nSET RecommendShop = @RecommendShop\r\nWHERE (ShopID = @ShopID) AND (ShopIdentify = 1) AND (ShopStatus = 1)";
			this._commandCollection[15].CommandType = CommandType.Text;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@RecommendShop", SqlDbType.Bit, 1, ParameterDirection.Input, 0, 0, "RecommendShop", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "Pr_SearchShopListPerPage";
			this._commandCollection[16].CommandType = CommandType.StoredProcedure;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 3000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@OrderBy", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "pr_SelectShopListByParentID";
			this._commandCollection[17].CommandType = CommandType.StoredProcedure;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@ParentID", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18] = new SqlCommand();
			this._commandCollection[18].Connection = this.Connection;
			this._commandCollection[18].CommandText = "UPDATE HLShop_Shop\r\nSET ShopName = @ShopName, ShopAnnouncement = @ShopAnnouncement, \r\n      ShopIntro = @ShopIntro, ShopCategoryID = @ShopCategoryID, \r\n      ShopImageUrl = @ShopImageUrl,ShopOperatorItem = @ShopOperatorItem,\r\n      ShopAddress=@ShopAddress\r\nWHERE (ShopID = @ShopID)";
			this._commandCollection[18].CommandType = CommandType.Text;
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, "ShopName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopAnnouncement", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, "ShopAnnouncement", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopIntro", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, "ShopIntro", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopCategoryID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopCategoryID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopImageUrl", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, "ShopImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopOperatorItem", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, "ShopOperatorItem", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopAddress", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, "ShopAddress", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[19] = new SqlCommand();
			this._commandCollection[19].Connection = this.Connection;
			this._commandCollection[19].CommandText = "  update hlshop_shop set shopproductnum =(SELECT sum(ProductID)\r\n   FROM hlshop_product  where \r\nEndDate>getdate() and   EnableSale=1 And EnableSingleSell=1 and SalerID=@userid And Stocks>0) where  ShopOwnerID=@userid";
			this._commandCollection[19].CommandType = CommandType.Text;
			this._commandCollection[19].Parameters.Add(new SqlParameter("@userid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopOwnerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20] = new SqlCommand();
			this._commandCollection[20].Connection = this.Connection;
			this._commandCollection[20].CommandText = "UPDATE [HLShop_Shop] SET  [ShopClick] =[ShopClick]+1, [ShopProductNum] = @ShopProductNum WHERE (([ShopID] = @ShopID))";
			this._commandCollection[20].CommandType = CommandType.Text;
			this._commandCollection[20].Parameters.Add(new SqlParameter("@ShopProductNum", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopProductNum", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[21] = new SqlCommand();
			this._commandCollection[21].Connection = this.Connection;
			this._commandCollection[21].CommandText = "pr_UpdateShopStatic";
			this._commandCollection[21].CommandType = CommandType.StoredProcedure;
			this._commandCollection[21].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@ShopStatus", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22] = new SqlCommand();
			this._commandCollection[22].Connection = this.Connection;
			this._commandCollection[22].CommandText = "UPDATE HLShop_Shop\r\nSET ShopTemplateID = @ShopTemplateID, ShopStyle = @ShopStyle\r\nWHERE (ShopID = @shopid)";
			this._commandCollection[22].CommandType = CommandType.Text;
			this._commandCollection[22].Parameters.Add(new SqlParameter("@ShopTemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopTemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22].Parameters.Add(new SqlParameter("@ShopStyle", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopStyle", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22].Parameters.Add(new SqlParameter("@shopid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetAllShop()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetLevelShop(int? ShopGroupID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[1];
			if (ShopGroupID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopGroupID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetNewShop()
		{
			this.Adapter.SelectCommand = this.CommandCollection[2];
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetRecommendShop()
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetshopbynameoweridoperatoritemaddressChildid(string shopname, string shopowername, string shopoperatoritem, string shopaddress, int? shopChildid)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (shopname == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = shopname;
			}
			if (shopowername == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = shopowername;
			}
			if (shopoperatoritem == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = shopoperatoritem;
			}
			if (shopaddress == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = shopaddress;
			}
			if (shopChildid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = shopChildid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShopByShopID(int ShopID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			this.Adapter.SelectCommand.Parameters[0].Value = ShopID;
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShopByShopNameShopIdenfityShopStatus(string ShopName, int? ShopIdentify, int? ShopStatus)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (ShopName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopName;
			}
			if (ShopIdentify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopIdentify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (ShopStatus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = ShopStatus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShopDIByShopOwnerID(int? ShopOwnerID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (ShopOwnerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ShopOwnerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShopPrePage(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShops()
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable GetShopUploadShopFile(string NickName, string UploadFileName, int? U_Identify)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = NickName;
			}
			if (UploadFileName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UploadFileName;
			}
			if (U_Identify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = U_Identify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable InsertShopGetShopID(int? ShopOwnerID, string ShopName, string ShopAdUrl, string ShopAnnouncement, int? ShopGroupID, System.DateTime? ShopRegDate, System.DateTime? ShopCloseDate, int? ShopClick, string ShopHelp, string ShopIntro, int? ShopCredit, bool? ShopStatus, int? ShopTemplateID, string ShopStyle, int? ShopCategoryID, int? ShopChildID, string ShopImageUrl, bool? RecommendShop, double? Tax, bool? IsTax, int? ZipCode, string ShopAddress, System.DateTime? LastTimeLogin, string ShopOperatorItem, int? ShopProductClassID, string ShopURL, int? ShopIdentify, string ShopOwnerName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (ShopOwnerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopOwnerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ShopName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopName;
			}
			if (ShopAdUrl == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = ShopAdUrl;
			}
			if (ShopAnnouncement == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = ShopAnnouncement;
			}
			if (ShopGroupID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = ShopGroupID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ShopRegDate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = ShopRegDate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (ShopCloseDate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = ShopCloseDate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (ShopClick.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = ShopClick.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (ShopHelp == null)
			{
				this.Adapter.SelectCommand.Parameters[9].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[9].Value = ShopHelp;
			}
			if (ShopIntro == null)
			{
				this.Adapter.SelectCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[10].Value = ShopIntro;
			}
			if (ShopCredit.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[11].Value = ShopCredit.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (ShopStatus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[12].Value = ShopStatus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (ShopTemplateID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[13].Value = ShopTemplateID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[13].Value = System.DBNull.Value;
			}
			if (ShopStyle == null)
			{
				this.Adapter.SelectCommand.Parameters[14].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[14].Value = ShopStyle;
			}
			if (ShopCategoryID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[15].Value = ShopCategoryID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (ShopChildID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[16].Value = ShopChildID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[16].Value = System.DBNull.Value;
			}
			if (ShopImageUrl == null)
			{
				this.Adapter.SelectCommand.Parameters[17].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[17].Value = ShopImageUrl;
			}
			if (RecommendShop.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[18].Value = RecommendShop.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (Tax.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[19].Value = Tax.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (IsTax.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[20].Value = IsTax.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (ZipCode.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[21].Value = ZipCode.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (ShopAddress == null)
			{
				this.Adapter.SelectCommand.Parameters[22].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[22].Value = ShopAddress;
			}
			if (LastTimeLogin.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[23].Value = LastTimeLogin.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (ShopOperatorItem == null)
			{
				this.Adapter.SelectCommand.Parameters[24].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[24].Value = ShopOperatorItem;
			}
			if (ShopProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[25].Value = ShopProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (ShopURL == null)
			{
				this.Adapter.SelectCommand.Parameters[26].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[26].Value = ShopURL;
			}
			if (ShopIdentify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[27].Value = ShopIdentify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (ShopOwnerName == null)
			{
				this.Adapter.SelectCommand.Parameters[28].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[28].Value = ShopOwnerName;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable SearchShopPerPage(int? PageSize, int? PageIndex, int? Counts, string strWhere, string OrderBy)
		{
			this.Adapter.SelectCommand = this.CommandCollection[16];
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = strWhere;
			}
			if (OrderBy == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = OrderBy;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable SelectShopListByParentID(string ParentID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[17];
			if (ParentID == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ParentID;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual F_Shop.HLShop_ShopDataTable UpdateShopStatus(int? ShopStatus, int? ShopID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[21];
			if (ShopStatus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopStatus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			F_Shop.HLShop_ShopDataTable hLShop_ShopDataTable = new F_Shop.HLShop_ShopDataTable();
			this.Adapter.Fill(hLShop_ShopDataTable);
			return hLShop_ShopDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(F_Shop.HLShop_ShopDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(F_Shop dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_Shop");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? GetShopCount()
		{
			SqlCommand sqlCommand = this.CommandCollection[7];
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int IdentifyShop(int? ShopIdentify, int ShopID)
		{
			SqlCommand sqlCommand = this.CommandCollection[12];
			if (ShopIdentify.HasValue)
			{
				sqlCommand.Parameters[0].Value = ShopIdentify.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ShopID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int pr_EditShopByShopID(string ShopID, string Type)
		{
			SqlCommand sqlCommand = this.CommandCollection[14];
			if (ShopID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ShopID;
			}
			if (Type == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = Type;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int RecommendShop(bool? RecommendShop1, int ShopID)
		{
			SqlCommand sqlCommand = this.CommandCollection[15];
			if (RecommendShop1.HasValue)
			{
				sqlCommand.Parameters[0].Value = RecommendShop1.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ShopID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateBaseShop(string ShopName, string ShopAnnouncement, string ShopIntro, int? ShopCategoryID, string ShopImageUrl, string ShopOperatorItem, string ShopAddress, int ShopID)
		{
			SqlCommand sqlCommand = this.CommandCollection[18];
			if (ShopName == null)
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = ShopName;
			}
			if (ShopAnnouncement == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ShopAnnouncement;
			}
			if (ShopIntro == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = ShopIntro;
			}
			if (ShopCategoryID.HasValue)
			{
				sqlCommand.Parameters[3].Value = ShopCategoryID.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (ShopImageUrl == null)
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = ShopImageUrl;
			}
			if (ShopOperatorItem == null)
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = ShopOperatorItem;
			}
			if (ShopAddress == null)
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = ShopAddress;
			}
			sqlCommand.Parameters[7].Value = ShopID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateCountShopProductNum(int? userid)
		{
			SqlCommand sqlCommand = this.CommandCollection[19];
			if (userid.HasValue)
			{
				sqlCommand.Parameters[0].Value = userid.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateShopOnSaleProductNum(int? ShopProductNum, int ShopID)
		{
			SqlCommand sqlCommand = this.CommandCollection[20];
			if (ShopProductNum.HasValue)
			{
				sqlCommand.Parameters[0].Value = ShopProductNum.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ShopID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateTem(int? ShopTemplateID, int? ShopStyle, int shopid)
		{
			SqlCommand sqlCommand = this.CommandCollection[22];
			if (ShopTemplateID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ShopTemplateID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ShopStyle.HasValue)
			{
				sqlCommand.Parameters[1].Value = ShopStyle.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[2].Value = shopid;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
